SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268045 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268045 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937522,982594,501404,749001,789713,1000856,410995,978750,718519,695364,369832,479770,1018721,1035537,596091,1022478,446606,682240,78033,1014177,250394,336260,612289,240810,868828,237145,210768,601026,58852,285138,938304,305355,482095,777551,24419,293488,826792,1000373,907852,320773,91734,26706,752160,784471,761437,166954,757047,692425,13231,553010,717447,977189,436294,483797,544784,199411,160713,1038170,820464,461823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]