SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021528 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021528 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492767,538628,404504,780429,375479,612893,487091,840840,844860,629941,900928,742592,366106,447206,196641,816390,985620,773550,157111,194645,267368,114506,155027,330337,106530,184497,297070,10933,669490,1037629,942341,573354,785815,843672,608934,470827,561902,473023,300374,327064,703076,976487,438718,815418,173618,860453,699309,161823,309665,610740,430267,45554,384157,508815,950960,1024700,994400,761018,148750,127688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]