SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535901 LIMIT 1 [ RunTime:0.001660s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535901 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279597,447816,32844,294210,57888,743318,837181,974920,593972,359566,317744,541214,42261,473446,670985,647591,205328,400338,924964,58252,18869,97162,320771,933367,301180,259709,102068,219421,794370,237563,460336,550114,945911,872523,795896,53676,141010,743156,99265,279408,49220,891921,699986,593075,87606,327900,315259,31032,85576,553313,95284,118572,462159,171774,539027,956996,156962,225210,190341,558410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]