SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501754 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501754 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912785,126753,936956,963413,574845,940374,578931,899091,88524,341684,1026320,554933,690922,226393,675699,856540,400765,184325,976561,591700,384657,169196,864492,436509,286612,336930,277608,970451,1029232,346218,741301,999023,953385,135980,954837,637695,541842,374112,562400,766155,14261,31920,807611,347842,839188,384024,141912,473500,781937,836459,860215,787737,952906,179748,356081,620008,194034,418679,846994,722981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]