SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269616 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269616 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030917,542812,923276,428104,745894,216945,923113,916353,633852,454281,650876,1000830,784363,423222,193021,166252,919827,405541,1020510,568531,509212,844959,366966,879584,457388,33825,250652,369535,551196,45837,19219,649972,104661,620520,250689,171903,330986,957847,685183,979296,39633,157255,750251,581904,115431,78824,1045051,87214,270547,701729,902789,278952,950925,530844,708046,861293,295388,1042262,132028,644516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]