SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530140 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530140 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009020,502227,994180,859790,170782,869642,649740,619720,477674,668005,312752,450616,173429,948044,185447,744901,743056,334671,946206,983845,887588,365503,1010250,631256,406575,770595,446428,830615,424567,571203,822909,344723,335506,556630,836847,1035119,50313,515307,924693,967029,500578,744094,300639,209534,186681,140353,665025,321685,109213,556144,325130,259705,1033805,870792,375707,42636,369832,503232,613318,4566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]