SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503879 LIMIT 1 [ RunTime:0.002879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503879 [ RunTime:0.005845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208591,888763,771868,928684,919804,189486,150976,320771,66318,70085,1006363,877144,459837,570331,349493,85484,198700,991044,157367,154064,340322,304693,461833,181964,853955,952735,618823,956974,295739,1022452,747892,279315,941094,645208,31304,985227,172967,735025,761178,146498,828741,85372,455828,657607,1004192,151108,891210,191915,580650,105476,405148,784132,489582,246984,1005934,394870,983058,290462,433154,276170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]