SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006416 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006416 [ RunTime:0.001421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628248,673292,14391,830927,394632,570350,497547,441924,941726,974336,872740,337874,228763,912610,303234,791938,222300,757336,698907,917925,673539,837741,801598,931331,881790,896124,971042,822680,914666,967506,965014,21478,130503,319999,261160,210853,1025449,67268,587372,1027588,193452,766331,50019,9699,371949,769825,221895,649370,625629,237381,43001,72966,277639,796347,344662,2269,446292,867695,539591,56773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]