SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263047 LIMIT 1 [ RunTime:0.000922s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263047 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175282,1039460,529499,287420,490772,99580,691554,136168,204568,141562,865909,535275,361639,490807,928210,142594,957442,803266,628858,306216,994379,590766,935365,842291,60732,786658,189677,874055,158931,291610,11985,1015723,204404,483234,238878,529153,944075,644567,682547,1027017,1023137,491973,980418,230775,709625,460819,599980,899941,957205,680836,474340,383471,245828,223126,1034463,301181,560339,993825,567443,983483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]