SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40514 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40514 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904370,994876,234071,198694,207927,315502,695425,957397,379876,422567,32617,527087,993355,4383,64804,745482,828574,1011746,455022,38594,985568,306188,24116,726975,740861,30414,568777,616617,162055,841981,836887,350011,930348,920357,364738,728557,296061,256781,416321,936922,780142,421573,154975,562640,302849,359801,547913,726477,95647,980886,43951,1017122,128658,44492,898809,1000466,926597,397658,533354,847469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]