SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841529 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841529 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935769,293528,447777,471974,884612,849874,18319,462088,656755,443471,435099,357592,409110,846828,512747,88198,833368,832039,585390,938160,434459,909635,150533,495116,587161,270454,771869,554120,216537,272341,840810,869886,188022,510405,115267,968924,630337,192398,313181,159367,944778,122812,23478,960351,1023112,902914,872896,120703,697006,988400,250169,931877,590655,554968,605103,153092,421826,482744,1043294,16990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]