SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001780s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 168250 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 168250 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29115,348472,908500,770140,634315,306691,574618,732152,1041222,139199,561573,926167,119013,952514,798899,589726,614961,960353,679422,892529,891316,399215,1013526,565665,687550,64229,771524,246373,382024,253367,168303,112153,141193,820432,596470,347181,361433,223020,960703,202634,875272,908620,269770,566352,409976,373965,801808,255259,28971,767568,161256,637821,706857,264882,367599,70950,252887,323128,127033,350939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 168250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 168250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]