SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042776 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042776 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623330,19546,109745,641861,768972,1031237,854085,240390,540318,53745,307139,628284,832783,334941,251703,941680,419382,420019,1047270,467664,584784,735473,10848,622879,356361,1032060,773001,519599,68,485964,179746,506706,362406,1032549,981577,395100,364075,949497,7319,267408,1005697,1022213,687778,197624,876296,398317,36551,110512,71742,825577,125795,763095,184585,424019,538989,651576,354559,664546,844583,597715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]