SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573718 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573718 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214020,715101,291711,469713,836742,59538,284421,751447,6673,552793,631352,881979,748579,614544,299521,138099,839490,815830,627407,278484,763744,615419,170068,411378,1004550,957537,140061,745862,503623,1020071,605393,915722,600735,541160,371878,749071,453086,740062,994929,358474,715671,923954,600274,611862,694405,482568,722060,426920,942165,362391,101757,144856,59760,470671,814094,219090,369500,457412,210054,765261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]