SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433943 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433943 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213665,1000407,70927,700700,823233,710636,164968,824892,895881,477562,691542,601369,150637,151134,340946,23980,968821,984097,539287,536002,752949,495123,1001076,571286,834753,359951,429063,68103,1000621,654163,937665,148193,440812,888949,306947,909086,624867,700967,531906,253598,17137,744839,748646,421063,4141,1023212,427202,421939,353513,205791,776121,1014197,380169,954346,289177,33623,882827,954012,256034,1038849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]