SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022252 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022252 [ RunTime:0.004400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575764,873977,94201,664417,417060,378003,374142,185014,315378,950575,110058,252491,167768,89064,534803,750027,607354,398791,106499,327944,4194,67016,362681,291868,438544,295880,714612,864145,902527,258309,913732,576480,437659,334886,386828,941507,456070,611705,954629,115964,630664,262844,975459,540561,155873,539820,433934,195600,289473,994410,412219,584216,258800,42498,292473,581570,16806,814447,937868,209655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]