SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148438 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148438 [ RunTime:0.003848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930203,775310,831252,411657,617224,729597,344033,893243,539836,735182,60566,711838,884260,2559,272275,439396,39693,151675,107760,77018,276020,166991,531478,678890,537586,879224,421499,580640,29885,571990,492533,71585,893104,794080,469304,219400,518567,135827,31432,147456,1007432,653257,210862,855993,988845,250152,673208,499960,570749,905967,594128,551441,24587,895676,1046600,857989,980654,546419,525445,295240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001048s ]