SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028640 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028640 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571031,839037,158473,185481,617186,692957,823783,1006466,813792,331131,758617,129184,638233,896000,517263,444941,625798,560863,419641,398,595314,629199,121269,472848,332967,374845,385483,55066,534056,49271,433872,999952,532710,372750,899894,364773,688739,712747,221361,282914,371603,528672,956333,21106,769443,537567,944738,34632,129694,649837,966595,942775,107904,974732,116857,862194,247038,349222,214170,279300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]