SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585906 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585906 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423066,367251,658406,152855,121831,141761,13810,801853,338079,636144,468205,687355,509330,510962,321050,516399,52405,14949,384860,358186,1010779,624421,811602,732541,718738,809758,469033,530419,1047953,275237,972338,115013,965405,177948,402331,1011776,342689,732509,643514,842408,432378,1014262,890826,963052,465511,607139,831980,817576,589081,735745,680452,641897,457083,903903,967927,1030675,180971,573596,721855,979185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]