SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510514 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510514 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749683,228619,683132,142827,607390,888085,240419,951152,360087,824446,839769,265330,856267,291997,275672,340176,63069,259708,712716,715028,536603,504468,578813,762737,727185,98371,409936,668993,276932,764552,110133,224774,119279,383821,656013,109946,352890,692767,989572,59181,430910,224592,39501,1045050,279377,976986,969839,701433,323730,1033337,922102,323319,283373,561297,987145,107829,326744,857692,174929,1010463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]