SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543246 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543246 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923839,917539,667513,511603,177081,384863,780809,865481,354291,74044,32038,639989,964173,247978,791431,771550,946134,834090,874285,1005273,524538,513205,1044287,679265,666558,922761,184718,400070,440373,550506,598808,156927,380924,365438,499743,862702,115957,361572,37618,570273,947978,456222,10935,272792,351177,398374,610273,519150,572081,171479,843943,393673,457980,86644,49178,912019,831432,185658,586768,201038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]