SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290840 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290840 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248398,506823,685640,1015658,449043,673060,180186,847734,926174,311028,124591,117344,25792,151630,831639,816533,1020928,381757,503151,866113,75074,468453,984632,532872,481251,981525,869372,273798,325227,512346,303531,812638,898822,715440,931106,457440,441223,605936,605297,816008,864541,835844,389580,794641,658324,1016122,197368,994249,600144,941404,266172,907855,850576,223251,376811,897778,1037294,785621,612841,403254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]