SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102140 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102140 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111104,619387,854619,866651,89560,251578,551064,724619,637424,570190,633836,261618,66259,771321,342586,660787,956490,144086,883633,165165,241029,690850,507689,81733,850498,465772,426779,601281,805626,20042,930115,402594,971376,754640,1002552,463622,768739,716236,318016,23078,873193,361131,19301,749332,431120,247123,184049,257844,154919,896572,618401,110543,593105,1009449,583840,574352,18053,777315,721443,920425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]