SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514211 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514211 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743921,932944,798535,569316,761702,113644,746567,358080,9154,545703,714833,1034445,933690,649375,508959,714950,940377,162264,844092,106375,290629,892883,863779,357074,67340,979023,653465,1027835,168335,572370,5878,971926,185521,892674,1017268,508967,334439,546354,852135,426225,715243,474138,487538,307736,536233,312168,97706,781131,839891,669288,952931,805147,918909,346142,665033,968414,804850,103336,773249,264726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]