SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421881 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421881 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585613,498611,197235,134793,515422,512187,379571,489517,315052,667870,708414,18140,257705,180892,978506,152217,375755,430849,864645,232167,293185,76149,947545,349208,685609,634406,241116,904995,894592,500138,768444,393469,222463,710290,155477,225007,261189,940912,494858,425847,459315,153768,364561,956227,149857,211573,958120,5182,315428,129260,704545,607032,392700,56776,261284,897868,82525,404181,514411,113243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]