SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017723 LIMIT 1 [ RunTime:0.001754s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017723 [ RunTime:0.006334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415504,296816,843710,829200,385540,509561,642788,733428,434509,400822,920837,570430,1002706,459794,169218,730949,95055,608587,351790,951456,351655,546890,722847,150999,513384,12117,1048732,710650,793489,484356,854778,287851,204353,379661,831489,927008,814178,178994,976784,149910,865435,660228,348901,967923,755307,349626,970356,451438,919742,207486,1038016,311311,484146,1019999,626778,1032638,243724,1023338,936031,741857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]