SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427181 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427181 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20612,289356,204779,873860,947908,634076,370966,782396,758051,998897,218333,233535,925825,905268,450600,789149,487977,1036875,742138,258667,726543,231094,970012,189196,518956,270937,496970,996805,179921,546693,165884,495921,1038492,825692,781265,260353,86754,1010066,391903,438158,631090,424086,478330,451086,430759,371564,2792,697639,472660,600877,47248,84810,1018073,1011148,114889,787160,574313,994164,333878,595644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001438s ]