SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457959 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457959 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570112,862435,352158,680595,544218,649784,387123,948200,1021491,411862,1002981,480596,327120,139750,845031,618107,875611,977336,257941,570685,122350,345462,91724,162950,925172,119870,455048,755661,60723,617166,249496,38632,122327,635484,641666,362901,99381,751366,717252,258700,981450,816126,1004288,345233,71465,680683,652190,175068,616845,473646,855102,1026924,135527,966840,826160,624494,21306,391256,634239,507064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]