SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465984 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465984 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423299,567665,357128,130456,727364,721277,160856,994813,1015157,553329,416452,968566,948290,628114,307885,979941,932879,942229,379544,193971,450286,725456,935952,612306,13975,734801,830578,629435,244614,266794,12041,804792,196305,289718,25489,431461,809591,658815,715430,444584,1037998,451523,7164,691828,819051,90871,87349,687765,617574,88163,707964,357487,494301,15979,579989,92909,318717,774235,751976,1019819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]