SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189999 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189999 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447473,539348,602302,1002818,16950,312009,784669,449461,3380,28551,702401,147271,414773,679047,51181,900093,42919,822174,206630,582863,208004,939889,735810,512882,515118,135947,837717,1008296,448817,276827,933257,681316,128189,590417,985013,760520,424506,24832,530571,850100,32518,154877,438822,123564,945263,566965,552559,210588,746894,22657,833661,720618,897093,896151,708500,450721,221848,858127,418582,670014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]