SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042112 LIMIT 1 [ RunTime:0.004369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042112 [ RunTime:0.009039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311677,175417,283376,244502,466745,677309,409753,52286,487663,857547,887132,478973,71843,1041597,696930,276879,28708,666734,994966,834938,529091,480581,391814,161615,701794,509565,806809,492670,871178,83005,650554,423947,1014896,1034453,925348,540423,631503,806316,793638,332571,948190,628385,235915,518636,931705,676962,970433,620732,402846,128986,907555,729396,533128,297137,520309,564125,991141,99877,503349,263668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]