SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196699 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196699 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352762,578963,105273,478012,640038,244336,685434,972228,187737,735018,759800,212481,195818,652549,874876,82619,152654,680570,569478,549447,790245,292091,977349,945300,804428,728272,989704,622895,220285,149840,980728,620383,139185,429111,1021115,1002337,17914,778937,662179,925502,253010,542893,212814,950724,764742,1016260,792561,731409,246680,217545,807179,842055,311844,440497,983766,634196,115942,525292,140878,201947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]