SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047220 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047220 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846831,431617,843257,14850,997016,1036263,201656,841064,404641,630993,525199,7953,1030903,520757,863429,634968,505933,142582,351941,325287,88319,400493,907348,281989,537290,388433,595526,498768,444367,44963,568403,2436,416917,157523,859976,416940,577502,238255,474634,736354,338454,301344,163040,665536,568179,30396,1001555,607874,142353,642597,442496,121259,232792,725087,234940,102981,492035,834821,732545,882953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]