SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450412 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450412 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780266,824791,231890,430761,60361,763778,184136,495214,282845,338760,582296,546400,743615,780824,48504,326712,989470,636832,124162,847068,311451,801811,513247,363471,755812,308681,717788,44786,438947,629403,378098,687302,430683,272007,92283,804798,407902,23321,1037003,799436,748665,532264,293635,885245,201350,732836,485044,912632,668767,321173,992088,517101,731000,131082,228090,55548,942259,132355,164567,132103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]