SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417782 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417782 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250587,937654,930434,332018,895151,400388,269996,385684,270137,921812,874755,457018,920428,6688,223409,715582,296106,793336,351633,320624,615481,957411,1038028,971401,368155,774560,312373,546531,23198,921074,228114,897197,944424,952478,367087,387589,625842,45736,701633,947436,626052,440800,126112,106012,770274,367173,82473,209829,827480,133938,88281,603491,905900,333417,574193,426708,877191,294677,873230,585400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]