SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591868 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591868 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447494,313961,62364,37546,478701,778438,938967,836726,597530,309932,377657,342577,21345,394110,661945,982599,223400,392172,678986,440357,643725,729306,1046844,346377,59575,506156,843142,646712,165983,401029,351481,988826,583677,969318,282890,508748,393798,969142,77588,767811,875300,408844,1004315,448140,444795,180968,845821,130749,933449,324940,578587,583880,161272,645158,74220,642211,664818,1043727,216884,52339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]