SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48110 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48110 [ RunTime:0.002742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407267,521723,374437,913370,348089,468433,533514,123542,671506,364280,1000844,952324,577371,753630,216160,339181,820216,753346,675422,176255,833302,944126,286908,83898,361138,522195,434385,792252,238435,400750,147588,194457,336203,364242,491521,215882,592501,362213,644726,838121,985767,683613,885018,55784,779301,6836,284055,745231,970914,309680,781059,284077,651504,140166,1001010,236342,331224,992027,817357,623493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]