SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417937 LIMIT 1 [ RunTime:0.005358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417937 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006578,79693,290228,398962,570125,240748,614102,194080,767148,983959,69730,633538,435220,100099,459951,120788,785172,70156,627256,463890,235494,824596,746298,4287,209480,596445,107447,1017153,809713,16682,740613,601029,210879,487833,526613,3224,64045,903241,777900,694780,47749,107570,564230,126246,38028,177887,324153,1047926,236479,778333,582803,113142,809280,1009400,141392,624158,494970,992262,950891,808433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]