SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413401 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413401 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847059,740835,622816,1001526,912500,1047312,65654,123759,1000078,447068,29596,916767,591951,336741,774508,104658,277887,186862,783100,514231,733672,102608,974598,771617,241581,409842,482353,776972,222303,671228,881680,712,799624,926815,748078,440984,279413,290859,141333,936813,606337,164048,1022475,998135,171709,231217,645542,893027,459415,155938,155814,279791,11416,130128,528725,6733,358379,772788,829260,154418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]