SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454313 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454313 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93281,418648,529146,1004021,611569,316946,157866,735038,318184,991132,46120,190790,710530,491273,518903,906862,432289,303892,711279,681447,584422,100245,214486,105363,741644,726497,838458,77239,766568,227987,448390,1045827,270734,852224,777535,464668,210870,307041,829751,802553,868928,871226,656819,419967,766714,638580,180531,810381,46352,465451,500480,790366,543128,439583,712195,610399,128203,58552,544720,599590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]