SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341483 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341483 [ RunTime:0.002482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51087,1007647,345222,746015,736883,505500,626319,102920,982816,154694,759118,546414,303867,127296,440226,857913,386243,68045,644258,155050,259124,472258,638561,64806,723535,918739,441629,525416,879167,129798,682237,382805,466739,73363,533162,412531,877013,468512,950164,12857,602397,72056,474397,158687,144095,1000200,481752,639298,131081,433168,740090,491189,106145,1019919,974074,963710,427687,435427,110240,571001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]