SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457028 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457028 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256552,355766,360072,570406,12947,781334,806844,790680,415213,354441,112626,710108,223758,748553,539424,167457,599739,422076,302404,997114,433925,1017752,415983,980754,339519,1034875,775380,735680,343523,869110,846820,602974,960508,770223,337306,490070,663234,684585,409141,275149,427893,721997,675255,19973,196963,573107,423387,939268,166392,247207,604944,319100,238261,794154,504979,278751,275555,797975,525283,554768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]