SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328969 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328969 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312774,318620,144486,473510,908760,223588,21676,303917,838259,327948,1045788,838160,661214,107265,360564,645587,601368,418163,128523,203139,775326,748345,190184,432857,81267,685891,198596,596346,200253,809847,956831,348716,801409,362743,511228,470009,969738,498497,879279,1013573,336623,561171,790405,28177,716154,1019193,216008,908164,360740,263480,305613,466499,176062,581222,47559,133112,838482,931984,863047,821432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]