SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402655 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402655 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537514,851738,212846,379567,516672,284698,58629,717311,978050,742818,363356,391351,520801,337719,276855,428750,746627,99914,346141,430026,339419,214343,564417,426554,850388,390760,220791,718112,473385,52024,516977,202205,852610,1001647,639014,58270,424680,54756,996197,265146,181392,762122,437769,73606,250956,368204,307580,505391,421997,33911,933100,272136,878271,147856,385839,275362,366836,141496,318218,58986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]