SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840028 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840028 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842126,876825,474402,218713,92503,149835,318636,1008502,350630,600816,916618,61746,708673,281025,154450,166972,1044089,213644,386128,488643,114996,999830,733532,911693,617504,630077,444365,898607,837813,1011144,709489,332498,134054,910862,957561,580038,992634,724278,583479,461417,913135,813526,835604,917716,798571,648752,1011083,667908,141395,181859,246516,242093,570038,486768,110887,448143,738239,603727,597626,928069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]