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` = 498331 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498331 [ RunTime:0.002778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858241,653480,1037325,363952,708199,249095,70986,1003277,72750,261026,21683,174221,201710,510393,203435,850551,1032523,665621,759916,385605,773236,404924,108804,393362,333189,909499,961279,167107,880893,112152,143905,866927,275559,223736,539116,499928,648919,600273,164283,91834,206684,606778,445838,969410,1041066,441685,416542,594213,70899,136022,763197,1028093,31839,954359,379290,638506,882591,41108,4706,815951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]