SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515447 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515447 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405907,103264,480698,362030,141063,588394,356530,899,438914,365643,1026680,778888,272982,882713,340826,331252,238545,981748,388706,594682,456053,739623,22143,894514,255147,698808,534216,458675,834501,159094,107822,587462,677556,62198,616206,161514,197761,642324,324782,865480,794492,817069,140182,182813,10933,32986,502078,845941,270370,296459,957880,199280,673878,152005,979294,689510,908140,348821,454121,395031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]