SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578063 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578063 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137792,456765,793945,195468,599543,828419,160563,134660,83033,138907,459925,321403,1025936,239018,360611,916855,150060,227606,537040,558829,971674,326635,266936,464760,768392,800741,24441,125556,968384,231902,642897,234938,396792,302610,327675,818704,298565,371376,498060,988121,980611,7204,773021,749557,669776,958954,83549,873243,341276,354228,248112,1044255,638232,513140,880179,372402,978501,55713,139738,706693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]