SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54178 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54178 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836263,536792,419712,366498,71560,88580,807212,707338,475960,578112,361687,456189,533897,410148,829625,155201,286572,857396,304404,943216,76116,564254,431519,334123,912857,960328,560848,299627,331549,502259,895522,287435,569195,285789,671969,124076,239519,159200,817933,500722,564008,918031,351143,552728,75161,159359,204601,372398,133713,258216,782826,67331,66873,919460,552974,657250,619850,596904,577246,781631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]