SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015204 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015204 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420008,68309,912623,930827,344673,517185,224242,253358,112448,511226,194116,798052,427520,1002908,134300,593232,677388,380509,926695,865330,228140,352535,287055,593677,681423,931293,272727,567538,171856,286883,599775,976194,930049,874304,97043,504084,1027538,6768,312564,747175,506913,982202,30356,853022,536260,735032,508253,74665,268890,317508,784453,588143,92957,208119,867059,778339,300242,692569,357998,829096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002052s ]