SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021914 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021914 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607519,474927,268422,375134,37164,161570,881676,225381,203966,390345,6877,529189,899481,237148,41404,1047458,707131,516076,159294,147755,737973,152430,18817,136076,267917,873447,183099,280335,747016,432169,510990,789125,223110,174076,30366,679577,237915,533873,614251,861938,152549,276696,396564,20511,168674,360551,217240,54511,460413,875201,449598,24192,73762,305536,764810,193012,973253,657939,182272,457474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]