SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431054 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431054 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500106,743837,77418,392944,908888,969826,41035,145335,140742,810634,251509,851727,358738,689052,497548,524358,895047,20302,292788,1042792,559508,1008831,439523,992017,558795,835075,904984,348448,137700,457799,368880,423909,656946,998447,292420,377236,978610,841384,704195,8389,907885,119513,891342,597365,401589,231544,296825,981306,1003566,957478,225728,638056,857814,306729,458442,309353,853421,755386,425203,644646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]