SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53271 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53271 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14872,753971,290114,632254,856015,821303,681060,952186,79789,20776,44521,609275,192589,152605,157549,812970,383227,1046660,785916,1014014,847748,774783,820837,615106,724872,608430,359003,887345,875906,724201,709067,997916,778962,320587,321520,29395,277626,869744,435159,109173,264669,318999,133445,188394,966840,918351,138392,376872,1021455,974623,587637,158082,113902,261736,872130,104991,213572,259208,27761,379320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]