SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203513 LIMIT 1 [ RunTime:0.004994s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203513 [ RunTime:0.008139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532651,684747,629066,64903,538914,664253,963776,422491,845638,359064,63110,208711,236959,351882,569852,545327,637838,788363,293016,374993,395322,537694,109047,336436,1010307,423834,290118,611448,341514,995893,786814,48793,918371,866305,653012,742761,679324,1010401,205956,918050,362270,476100,184280,295792,21715,564972,663675,1017086,744505,802900,137880,91938,609841,581854,67002,652855,1005120,254793,163310,414739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002966s ]