SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803063 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803063 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749107,296865,374,479093,822529,1015954,328816,338475,408369,359522,252965,115825,276996,850054,437222,986591,115134,951310,143194,916687,842462,795920,974166,498743,850944,85817,1026196,531343,765291,494219,262059,584252,1011222,724379,370330,205928,292931,505714,961213,685163,820685,169893,131324,966521,591926,983744,268608,458229,55460,506582,775921,158560,478301,308064,246116,467053,900136,458369,899784,895971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]