SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023081 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023081 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571279,1011832,960889,117249,843452,655054,3817,597643,921763,294967,1025778,1032519,704566,760943,855973,369950,942782,739171,323414,556720,892445,266622,559142,846513,759354,965728,867579,663763,903813,549734,623933,507657,335402,276242,313286,337212,899199,419413,32395,64368,648655,594904,743098,522213,217755,201231,381565,770076,935307,78149,338645,993422,763195,703876,1003625,492380,297096,824717,506894,588604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]