SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501241 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501241 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88798,394898,894143,523730,380256,483897,802951,529727,986614,54099,828934,752610,147917,376422,324117,1032644,777524,953460,319084,236259,1001787,750593,91670,351151,124756,287346,60411,797881,72133,669041,781874,186789,55704,90658,687463,782121,892849,360307,582762,534515,268613,769023,464872,672740,457340,25477,841171,814864,776898,267742,1040623,988925,227316,408815,855860,1006194,740828,1030997,1032996,331006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]